package com.itheima.dao;

import com.itheima.pojo.Student;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * Create By Awen on 2021/8/22
 *
 * @author Awen
 */
public interface StudentMapper {
    @Select("select * from student limit #{startIndex},#{pageSize}")
    List<Student> queryStudentsByPage(@Param("startIndex") int startIndex,@Param("pageSize") int pageSize);

    @Select("select count(*) from student")
    int queryCountStudents();
}